Diamonds EDA Extended Report

Dataset statistics

Number of variables	10
Number of observations	4990
Missing cells	0
Missing cells (%)	0.0%
Total size in memory	428.8 KiB
Average record size in memory	88.0 B

Variable types

Numeric	10

Alerts

`carat` is highly overall correlated with `price` and 3 other fields	High correlation
`price` is highly overall correlated with `carat` and 3 other fields	High correlation
`x` is highly overall correlated with `carat` and 3 other fields	High correlation
`y` is highly overall correlated with `carat` and 3 other fields	High correlation
`z` is highly overall correlated with `carat` and 3 other fields	High correlation
`cut` has 158 (3.2%) zeros	Zeros
`color` has 248 (5.0%) zeros	Zeros
`clarity` has 64 (1.3%) zeros	Zeros

Reproduction

Analysis started	2024-04-22 18:10:38.197099
Analysis finished	2024-04-22 18:10:45.751577
Duration	7.55 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

carat
Real number (ℝ)

HIGH CORRELATION

Distinct	202
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.79401804

Minimum	0.23
Maximum	4.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0.23
5-th percentile	0.3
Q1	0.4
median	0.7
Q3	1.04
95-th percentile	1.67
Maximum	4.13
Range	3.9
Interquartile range (IQR)	0.64

Descriptive statistics

Standard deviation	0.46798638
Coefficient of variation (CV)	0.58939011
Kurtosis	1.1572604
Mean	0.79401804
Median Absolute Deviation (MAD)	0.32
Skewness	1.0762322
Sum	3962.15
Variance	0.21901125
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3	250	5.0%
1.01	228	4.6%
0.31	207	4.1%
0.32	192	3.8%
0.7	167	3.3%
0.9	143	2.9%
1	142	2.8%
0.41	124	2.5%
0.4	121	2.4%
0.5	117	2.3%
Other values (192)	3299	66.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.23	37	0.7%
0.24	12	0.2%
0.25	17	0.3%
0.26	30	0.6%
0.27	24	0.5%
0.28	14	0.3%
0.29	12	0.2%
0.3	250	5.0%
0.31	207	4.1%
0.32	192	3.8%

Value	Count	Frequency (%)
4.13	1	< 0.1%
3.01	2	< 0.1%
2.53	1	< 0.1%
2.52	2	< 0.1%
2.51	1	< 0.1%
2.5	2	< 0.1%
2.48	1	< 0.1%
2.47	1	< 0.1%
2.44	1	< 0.1%
2.42	2	< 0.1%

cut
Real number (ℝ)

ZEROS

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7611222

Minimum	0
Maximum	4
Zeros	158
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.0354759
Coefficient of variation (CV)	0.37501995
Kurtosis	-0.036761531
Mean	2.7611222
Median Absolute Deviation (MAD)	1
Skewness	-0.68966193
Sum	13778
Variance	1.0722104
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
3	1988	39.8%
4	1291	25.9%
2	1097	22.0%
1	456	9.1%
0	158	3.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	158	3.2%
1	456	9.1%
2	1097	22.0%
3	1988	39.8%
4	1291	25.9%

Value	Count	Frequency (%)
4	1291	25.9%
3	1988	39.8%
2	1097	22.0%
1	456	9.1%
0	158	3.2%

color
Real number (ℝ)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3921844

Minimum	0
Maximum	6
Zeros	248
Zeros (%)	5.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6912101
Coefficient of variation (CV)	0.49856077
Kurtosis	-0.86816693
Mean	3.3921844
Median Absolute Deviation (MAD)	1
Skewness	-0.17065934
Sum	16927
Variance	2.8601915
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	1095	21.9%
5	917	18.4%
4	843	16.9%
2	763	15.3%
6	607	12.2%
1	517	10.4%
0	248	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	248	5.0%
1	517	10.4%
2	763	15.3%
3	1095	21.9%
4	843	16.9%
5	917	18.4%
6	607	12.2%

Value	Count	Frequency (%)
6	607	12.2%
5	917	18.4%
4	843	16.9%
3	1095	21.9%
2	763	15.3%
1	517	10.4%
0	248	5.0%

clarity
Real number (ℝ)

ZEROS

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0597194

Minimum	0
Maximum	7
Zeros	64
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	7
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.632269
Coefficient of variation (CV)	0.53347016
Kurtosis	-0.41489066
Mean	3.0597194
Median Absolute Deviation (MAD)	1
Skewness	0.52608155
Sum	15268
Variance	2.6643022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	1191	23.9%
3	1131	22.7%
1	843	16.9%
4	801	16.1%
5	464	9.3%
6	346	6.9%
7	150	3.0%
0	64	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	64	1.3%
1	843	16.9%
2	1191	23.9%
3	1131	22.7%
4	801	16.1%
5	464	9.3%
6	346	6.9%
7	150	3.0%

Value	Count	Frequency (%)
7	150	3.0%
6	346	6.9%
5	464	9.3%
4	801	16.1%
3	1131	22.7%
2	1191	23.9%
1	843	16.9%
0	64	1.3%

depth
Real number (ℝ)

Distinct	121
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.710741

Minimum	44
Maximum	70.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	44
5-th percentile	59.2
Q1	61
median	61.8
Q3	62.5
95-th percentile	63.8
Maximum	70.2
Range	26.2
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.445436
Coefficient of variation (CV)	0.023422762
Kurtosis	7.1154314
Mean	61.710741
Median Absolute Deviation (MAD)	0.7
Skewness	-0.4492632
Sum	307936.6
Variance	2.0892853
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	225	4.5%
61.6	203	4.1%
62.1	193	3.9%
62.2	191	3.8%
61.9	186	3.7%
62.3	182	3.6%
61.8	178	3.6%
61.5	177	3.5%
61.7	169	3.4%
61.3	147	2.9%
Other values (111)	3139	62.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44	1	< 0.1%
53	1	< 0.1%
55.3	1	< 0.1%
55.8	2	< 0.1%
55.9	1	< 0.1%
56.3	3	0.1%
56.5	2	< 0.1%
56.6	1	< 0.1%
56.7	3	0.1%
56.8	3	0.1%

Value	Count	Frequency (%)
70.2	1	< 0.1%
69.8	2	< 0.1%
69.6	1	< 0.1%
68.6	1	< 0.1%
68.5	1	< 0.1%
68.1	1	< 0.1%
67.9	1	< 0.1%
67.8	1	< 0.1%
67.6	2	< 0.1%
67.5	1	< 0.1%

table
Real number (ℝ)

Distinct	78
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.446152

Minimum	51.6
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	51.6
5-th percentile	54
Q1	56
median	57
Q3	59
95-th percentile	61
Maximum	95
Range	43.4
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2595345
Coefficient of variation (CV)	0.039333088
Kurtosis	15.529192
Mean	57.446152
Median Absolute Deviation (MAD)	1
Skewness	1.4790147
Sum	286656.3
Variance	5.1054963
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56	918	18.4%
57	889	17.8%
58	765	15.3%
59	640	12.8%
55	584	11.7%
60	361	7.2%
54	236	4.7%
61	209	4.2%
62	121	2.4%
63	59	1.2%
Other values (68)	208	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51.6	1	< 0.1%
52	6	0.1%
53	50	1.0%
53.1	1	< 0.1%
53.3	1	< 0.1%
53.4	1	< 0.1%
53.5	2	< 0.1%
53.6	1	< 0.1%
53.7	2	< 0.1%
53.8	5	0.1%

Value	Count	Frequency (%)
95	1	< 0.1%
70	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	7	0.1%
65.4	1	< 0.1%
65	8	0.2%
64.2	1	< 0.1%
64	26	0.5%
63	59	1.2%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	3177
Distinct (%)	63.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3929.9255

Minimum	351
Maximum	18787
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	351
5-th percentile	544
Q1	942
median	2397
Q3	5375.25
95-th percentile	12925.15
Maximum	18787
Range	18436
Interquartile range (IQR)	4433.25

Descriptive statistics

Standard deviation	3970.7961
Coefficient of variation (CV)	1.0103998
Kurtosis	2.0798183
Mean	3929.9255
Median Absolute Deviation (MAD)	1688
Skewness	1.5876822
Sum	19610328
Variance	15767222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
776	15	0.3%
765	15	0.3%
605	15	0.3%
561	14	0.3%
698	14	0.3%
625	13	0.3%
526	13	0.3%
544	13	0.3%
552	12	0.2%
878	11	0.2%
Other values (3167)	4855	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
351	2	< 0.1%
357	2	< 0.1%
361	1	< 0.1%
362	1	< 0.1%
363	1	< 0.1%
367	1	< 0.1%
373	1	< 0.1%
377	1	< 0.1%
383	1	< 0.1%
384	2	< 0.1%

Value	Count	Frequency (%)
18787	1	< 0.1%
18777	1	< 0.1%
18741	1	< 0.1%
18705	1	< 0.1%
18656	1	< 0.1%
18541	1	< 0.1%
18515	1	< 0.1%
18493	1	< 0.1%
18445	1	< 0.1%
18430	1	< 0.1%

x
Real number (ℝ)

HIGH CORRELATION

Distinct	473
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7259459

Minimum	3.86
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	3.86
5-th percentile	4.29
Q1	4.7
median	5.69
Q3	6.54
95-th percentile	7.6155
Maximum	10
Range	6.14
Interquartile range (IQR)	1.84

Descriptive statistics

Standard deviation	1.1163279
Coefficient of variation (CV)	0.19495956
Kurtosis	-0.74836092
Mean	5.7259459
Median Absolute Deviation (MAD)	0.92
Skewness	0.37792194
Sum	28572.47
Variance	1.2461879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.37	50	1.0%
4.38	49	1.0%
4.34	46	0.9%
4.35	45	0.9%
4.32	44	0.9%
4.31	40	0.8%
4.4	37	0.7%
4.29	35	0.7%
6.43	34	0.7%
4.39	34	0.7%
Other values (463)	4576	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.86	2	< 0.1%
3.88	2	< 0.1%
3.89	1	< 0.1%
3.9	2	< 0.1%
3.91	2	< 0.1%
3.92	4	0.1%
3.93	4	0.1%
3.94	6	0.1%
3.95	3	0.1%
3.96	4	0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9.44	1	< 0.1%
9.24	1	< 0.1%
8.89	1	< 0.1%
8.87	1	< 0.1%
8.83	1	< 0.1%
8.8	1	< 0.1%
8.72	1	< 0.1%
8.68	1	< 0.1%
8.64	1	< 0.1%

y
Real number (ℝ)

HIGH CORRELATION

Distinct	470
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7285531

Minimum	3.84
Maximum	9.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	3.84
5-th percentile	4.29
Q1	4.71
median	5.7
Q3	6.5375
95-th percentile	7.5855
Maximum	9.85
Range	6.01
Interquartile range (IQR)	1.8275

Descriptive statistics

Standard deviation	1.1092175
Coefficient of variation (CV)	0.19362962
Kurtosis	-0.76723114
Mean	5.7285531
Median Absolute Deviation (MAD)	0.92
Skewness	0.36930645
Sum	28585.48
Variance	1.2303636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.34	52	1.0%
4.39	43	0.9%
4.35	39	0.8%
4.37	39	0.8%
4.41	39	0.8%
4.32	39	0.8%
4.38	37	0.7%
4.33	36	0.7%
4.29	35	0.7%
4.4	35	0.7%
Other values (460)	4596	92.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.84	1	< 0.1%
3.89	2	< 0.1%
3.9	2	< 0.1%
3.92	1	< 0.1%
3.93	1	< 0.1%
3.94	2	< 0.1%
3.95	6	0.1%
3.96	5	0.1%
3.97	4	0.1%
3.98	3	0.1%

Value	Count	Frequency (%)
9.85	1	< 0.1%
9.37	1	< 0.1%
9.13	1	< 0.1%
8.93	1	< 0.1%
8.87	1	< 0.1%
8.83	1	< 0.1%
8.78	1	< 0.1%
8.66	1	< 0.1%
8.65	1	< 0.1%
8.62	1	< 0.1%

z
Real number (ℝ)

HIGH CORRELATION

Distinct	303
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.533503

Minimum	1.41
Maximum	6.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	1.41
5-th percentile	2.65
Q1	2.9
median	3.525
Q3	4.03
95-th percentile	4.68
Maximum	6.43
Range	5.02
Interquartile range (IQR)	1.13

Descriptive statistics

Standard deviation	0.68847914
Coefficient of variation (CV)	0.19484323
Kurtosis	-0.71104399
Mean	3.533503
Median Absolute Deviation (MAD)	0.565
Skewness	0.37604629
Sum	17632.18
Variance	0.47400352
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.69	77	1.5%
2.73	72	1.4%
2.72	71	1.4%
2.7	66	1.3%
2.71	66	1.3%
2.68	64	1.3%
2.67	59	1.2%
2.74	58	1.2%
2.66	56	1.1%
4.02	56	1.1%
Other values (293)	4345	87.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.41	1	< 0.1%
2.35	1	< 0.1%
2.37	1	< 0.1%
2.38	1	< 0.1%
2.39	2	< 0.1%
2.4	2	< 0.1%
2.41	1	< 0.1%
2.42	4	0.1%
2.43	6	0.1%
2.44	10	0.2%

Value	Count	Frequency (%)
6.43	1	< 0.1%
6.16	1	< 0.1%
5.73	1	< 0.1%
5.62	1	< 0.1%
5.6	1	< 0.1%
5.53	1	< 0.1%
5.43	1	< 0.1%
5.42	1	< 0.1%
5.41	1	< 0.1%
5.39	1	< 0.1%

Auto

Heatmap
Table

	carat	clarity	color	cut	depth	price	table	x	y	z
carat	1.000	-0.346	-0.243	0.020	-0.003	0.962	0.205	0.997	0.996	0.994
clarity	-0.346	1.000	-0.042	0.042	-0.071	-0.180	-0.147	-0.343	-0.338	-0.348
color	-0.243	-0.042	1.000	-0.032	-0.025	-0.142	-0.035	-0.239	-0.239	-0.244
cut	0.020	0.042	-0.032	1.000	-0.288	0.039	0.073	0.041	0.024	-0.006
depth	-0.003	-0.071	-0.025	-0.288	1.000	-0.019	-0.264	-0.057	-0.059	0.072
price	0.962	-0.180	-0.142	0.039	-0.019	1.000	0.183	0.963	0.962	0.957
table	0.205	-0.147	-0.035	0.073	-0.264	0.183	1.000	0.214	0.206	0.170
x	0.997	-0.343	-0.239	0.041	-0.057	0.963	0.214	1.000	0.998	0.988
y	0.996	-0.338	-0.239	0.024	-0.059	0.962	0.206	0.998	1.000	0.987
z	0.994	-0.348	-0.244	-0.006	0.072	0.957	0.170	0.988	0.987	1.000

Overview

Variables

Interactions

Correlations